@echo off

set USERNAME=root
set /P PASSWORD="Enter your ROOT password here: "

mysql -u%USERNAME% -p%PASSWORD% < createCoffeeShopTestSchema.sql
echo "Create coffee_shop_test schema successfully."

mysql -u%USERNAME% -p%PASSWORD% coffee_shop_test < importCoffeeShopTestDB.sql
echo "Import columns and data of coffee_shop_test schema successfully."

echo "Import Successfully!"
pause;